Writing and scheduling X (Twitter) posts one-by-one is tedious. If you plan your content in batches, AURA's bulk CSV import tool lets you upload your entire content calendar directly into the visual queue in seconds.

Here is your complete step-by-step guide to doing it right the first time.

Step 1 Prepare your CSV file

First, open your spreadsheet program of choice—Google Sheets, Microsoft Excel, or Apple Numbers.

Create a new sheet with exactly three columns in the first row. The column names are case-sensitive and must be written exactly as shown below:

Spreadsheet Columns & Format Example CSV Format
text scheduledTime media (optional)
Growing an audience isn't about hacks.

It's about writing compound content daily.		 2026-07-20 07:00:00 image_1.png
1/ Direct marketing is a science.

Here is a short thread on how we did it. ---TWEET_SEP--- 2/ Step 1: Hook the reader. ---TWEET_SEP--- 3/ Step 2: Pitch the value.		 2026-07-21 07:00:00
GM kings ☀️. Let's make today productive. 2026-07-22 07:00:00 graphic_v2.jpg
lightbulb Important Formatting Tips
  • Line Breaks: To add real line breaks inside your post, press Alt + Enter (Windows) or Cmd + Enter (Mac) inside the cell in Google Sheets.
  • Scheduling Threads: To schedule a multi-tweet thread, write your tweets in the text column and separate them using the special divider code ---TWEET_SEP---.
  • Date & Time Format: Time must be written strictly in the format: YYYY-MM-DD HH:MM:SS (e.g. 2026-07-20 07:00:00).
  • Media Attachments: For images or graphics, type in the exact filename (e.g., image_5.jpg). Ensure these files are already present in your AURA Media Gallery or bulk-images folder.

Step 2 Save the file correctly

Once your content is ready, save it using the CSV format:

  1. In Google Sheets: Click File → Download → Comma Separated Values (.csv).
  2. In Excel: Click Save As, choose a folder, and select CSV UTF-8 (Comma delimited) (*.csv) from the file type menu. (Saving in UTF-8 format is crucial to preserve emojis and special Cyrillic or non-Latin characters!).
  3. Name your file something simple, like my_posts.csv.

Step 3 Upload to AURA

Now, bring your posts to life inside the AURA dashboard:

  1. Open the AURA web app and navigate to the Calendar or Scheduled tab.
  2. Click the **“Bulk Import”** button (marked as "Import CSV" at the top right of the scheduler header).
  3. Select the my_posts.csv file from your computer.
  4. Review the quick preview screen showing all parsed posts, dates, and validation status.
  5. If everything looks correct, click Confirm Import.

That's it! Your entire content pipeline is uploaded, visualised, and scheduled. You can now relax while AURA publishes your posts automatically on X.