All Collections
Troubleshooting
Formatting
How to solve date and time format issues?
How to solve date and time format issues?

How to adjust date and time formats in connected sheets?

Eugenia Langen avatar
Written by Eugenia Langen
Updated over a week ago

When you create a connection with Sheetgo and the data is transferred for the first time, some number formats may arrive differently in the destination sheet. This includes date and time formats.

To make sure the format is correct:

  • Open the destination tab.

  • Select the entire column.

  • Go to the spreadsheet menu Format > Number and select the right format.
    โ€‹

    dates

This action is necessary only once per connected tab. Whenever the connection and data are updated, the formatting will remain the same.

If you're using Google Sheets and a single or append connection, try the transfer formatting setting.

Spreadsheet settings

It's also important to make sure you're using the correct settings for your time zone and location.

  • Open a Google Sheets file.

  • Go to File > Settings.

Changing these settings will adjust all formatting in your document.

Importing date formatting from Excel or CSV files

If you're importing dates from an Excel or CSV file, you need to tell Sheetgo which format to apply under Settings. Read more here.

Need more help?

Contact us via chat, on our email ([email protected]), or send us a ticket!

Visit our Community for help, tips, tricks, and feedback for Sheetgo.

Did this answer your question?