How to Get Shopify Orders to Google Sheets Every Week

To get Shopify orders into Google Sheets every week without rebuilding the file each time, save one export template, export the same closed date window every week (for example Monday to Sunday) as an XLSX or CSV file, and import it into the sheet as a new tab named after that window. To see which orders you’ve already sent, tag the orders you export, or keep one tab per week so each order belongs to exactly one window.

Every Monday the routine is the same for a lot of shops. Someone opens Shopify, exports last week’s orders, fixes the columns, pastes the rows into the Google Sheet the workshop or accountant uses, and tries to remember which orders went over last time. The download isn’t the real problem. The real problem is not knowing which orders are already in the sheet, and finding a missing order only at production or month-end close.

This guide sets up a routine that removes the guessing. It uses Columna: Order Export & Sheets for the export, but the date window and checks work with any export.

Why do I keep asking “which orders did I already send?”

Two things go wrong with an export you build by hand each week:

• Overlap. You export “last 7 days” on a Tuesday instead of a Monday and paste some orders twice.
• Gaps. An order falls between two exports and nobody notices.

Both come from the same cause: the export isn’t tied to a fixed rule. A second problem is the content. If you sell personalised products, the engraving text, gift messages and upload links are line item properties, and the standard Shopify order CSV has no column for them. So the file is missing what the workshop needs, and someone copies it from each order page. Our guide to exporting orders with line item properties explains why.

How do I set up the export once instead of every week?

Build one saved template that matches your sheet.

1. Open Columna and start a new export template.
2. Pick the columns your sheet uses, such as order number, created date, customer, line item, SKU and quantity, in the order your sheet expects. Rename the headers if your sheet uses different names.
3. Add your line item properties as columns. The app scans your last 250 orders for property keys and offers a column for each, named Property: <key>, so engraving text and gift messages each get their own column.
4. Save the template with a clear name, like “Weekly workshop sheet”.

If your sheet’s columns are already fixed, for example a shared accounting sheet, match the template’s column order to it. Then every file lines up without rearranging.

Which date range should a weekly export use?

Use a closed window that starts exactly where the last one ended.

1. Pick one date field and stick to it. Created date is the usual choice for production. For accounting, read Shopify order export for accounting first.
2. Export whole weeks that have already ended, such as Monday 00:00 to Sunday 23:59 in your store’s time zone.
3. Add the status filters your sheet needs, such as paid and unfulfilled orders for a workshop.
4. Export the file as XLSX or CSV. Columna builds it in your browser and saves it to your device.

A closed window means rerunning the same week gives the same orders, and the next week can’t overlap with this one.

How do I get the file into Google Sheets?

1. In Google Sheets, open the sheet your team uses.
2. Choose File > Import, then Upload, and select the file.
3. Choose Insert new sheet(s), so earlier weeks stay untouched.
4. Rename the new tab after the window, for example “Orders 2026-10-26 to 2026-11-01”.

Here are the ways to get the file there, side by side:

Option	What you do each week	Plan in Columna
Manual export and import	Run the saved template for last week, then import the file as a new tab	Every plan
Scheduled email export	Open the weekly email with the file and import it	Pro
Google Sheets sync	Check the synced sheet	One sync on every plan, up to 5 on Pro

For what Shopify’s own tools can and can’t schedule, see scheduled Shopify order exports.

How can I tell which orders are already in the sheet?

Pick one of these and use it every week.

• One tab per window. If the tab for a week exists, that week’s orders are in. Because the windows don’t overlap, each order belongs to exactly one tab.
• Tag the orders you export. Columna can tag the orders you exported. It’s optional: if you turn it on, the app also asks for permission to write orders, only to add that tag. The tag then shows on each order in Shopify, so anyone can see it has been sent.

Tags help most when orders arrive late or someone exports outside the normal window, because the tag stays on the order whatever date it was exported.

How do I check that nothing is missing?

A two-minute check before you share the sheet:

1. Compare the number of orders in the new tab with the order count in Shopify’s Orders list for the same dates and filters. A multi-item order has one row per line item, so count order numbers, not rows.
2. Spot-check one order with a line item property. The engraving text or gift message should be in its own column.
3. Look at one recent refund or cancellation and confirm it appears, or doesn’t, the way your sheet expects.
4. If anything doesn’t match, re-run the export for that window before anyone works from it.

Quick weekly routine

1. Same template, same weekday, same closed date window.
2. Export as XLSX or CSV, or use the scheduled email or Sheets sync.
3. Import as a new tab named after the window.
4. Check the order count and one personalised order.

FAQ

Can Google Sheets open an Excel file from Shopify orders?

Yes. Use File > Import > Upload in Google Sheets and choose to insert it as a new sheet. Google Sheets reads both XLSX and CSV.

Why do my rows repeat the same order number?

The export has one row per line item, so each item keeps its own engraving text or option. The order number repeats so you can still group rows by order.

Should I export “last 7 days” or a fixed week?

A fixed week. “Last 7 days” depends on when you run it, which causes overlaps and gaps. A closed Monday-to-Sunday window gives the same result every time you run it.

Does tagging exported orders change anything else on the order?

No. With tagging turned on, Columna only adds a tag to the orders you exported. It doesn’t edit products, customers or orders otherwise.

Try Columna: Order Export & Sheets

Columna: Order Export & Sheets exports Shopify orders to CSV or XLSX with line-item properties, such as engraving text, gift messages and upload links, each in its own column. The file is processed in your browser. It is made for shops that hand orders to production, fulfilment or accounting.

Ready to stop rebuilding the same file every Monday? Try Columna: Order Export & Sheets on the Shopify App Store, save your weekly template once and run this week’s export.