Macbook Collection import issue

Hello Team,

Im facing issue’s while import the excel.json format file to the postman tool in Macbook. Facing " Incorrect format - We don’t recognize/support this format." validation message on screen.

can anyone help me out asap.

Hey @altimetry-operator-1 :wave:t2:

The import feature will only import a valid and recognised format that it can parse and create an element.

What is excel.json? Is it a Collection? A datafile? Something else?

Hey Dan,
Thanks for your quick response.

I’ve tried to import a valid file. But tool is not allowing me to import any excel format file’s.

its a data file. PFA

Data files of a certain format, either JSON or CSV, can only be used with features like the Collection Runner, Monitors, etc.

You wouldn’t use the Import feature to add these.

Okay, But why !!! Is this applicable only for mac user’s to use "Run collection’s " for import??? why i could not able to import CSV files (changed to Json format) directly.

I have referred some video’s in youtube they are uploading the CSV format which are changed to json format. Post man is allowing those formats for window’s user.

Can i get some clarity on this ? My requirement is above attached screenshot should be imported to Postman tool for mac user.

Note : When i attempt to upload the file via Run collection, it is working fine.

The Import feature only accepts certain formats:

Postman can import and export Postman data, including collections, environments, globals, and data dumps. Postman can also import non-Postman data, such as API definitions and data from other API clients, to help you unify your API development workflow.

A datafile is not one of those formats as it wouldn’t be able to do anything with that file, as a standalone element. A Collection file would create a Collection, An Environment file would create an Environment, etc.

For the Collection Runner, you can use either a correctly formatted JSON file in the structure that Postman accepts or a CSV file - Those are added using the configuration options in the Collection Runner.

The file you included is not a CSV file, it’s an excel file. An example of those formats can be found here:

Thanks for your valuable comments

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.